%%{init: {'themeVariables': { 'fontSize': '12px'}}}%%
graph TD
    classDef path fill:#eee,stroke:#000,color:#000
    classDef plan fill:#fff,stroke-width:1px,color:#000
    classDef itemplan fill:#fff,stroke-width:2px,color:#000
    classDef unbatchedplan fill:#dff,stroke-width:1px,color:#000
    classDef sideeffectplan fill:#fcc,stroke-width:2px,color:#000
    classDef bucket fill:#f6f6f6,color:#000,stroke-width:2px,text-align:left

    subgraph "Buckets for queries/refs/books-related-people-plural-ref"
    Bucket0("Bucket 0 (root)<br /><br />1: <br />ᐳ: Access[9], Access[10], Object[11]<br />2: PgSelect[8]<br />3: Connection[12]<br />4: ConnectionItems[14]"):::bucket
    Bucket1("Bucket 1 (nullableBoundary)<br />Deps: 12, 14, 11<br /><br />ROOT Connectionᐸ8ᐳ[12]"):::bucket
    Bucket3("Bucket 3 (listItem)<br />Deps: 11<br /><br />ROOT __Item{3}ᐸ14ᐳ[17]"):::bucket
    Bucket4("Bucket 4 (nullableBoundary)<br />Deps: 18, 11<br /><br />ROOT PgSelectSingle{3}ᐸbooksᐳ[18]<br />1: <br />ᐳ: 19, 25<br />2: PgSelect[21]<br />3: Connection[26]<br />4: ConnectionItems[28]"):::bucket
    Bucket6("Bucket 6 (listItem)<br /><br />ROOT __Item{6}ᐸ28ᐳ[31]"):::bucket
    Bucket7("Bucket 7 (nullableBoundary)<br />Deps: 32<br /><br />ROOT PgSelectSingle{6}ᐸpeopleᐳ[32]"):::bucket
    end
    Bucket0 --> Bucket1
    Bucket1 --> Bucket3
    Bucket3 --> Bucket4
    Bucket4 --> Bucket6
    Bucket6 --> Bucket7

    %% plan dependencies
    Object11{{"Object[11∈0] ➊<br />ᐸ{pgSettings,withPgClient}ᐳ<br />Dependents: 2"}}:::plan
    Access9{{"Access[9∈0] ➊<br />ᐸ2.pgSettingsᐳ"}}:::plan
    Access10{{"Access[10∈0] ➊<br />ᐸ2.withPgClientᐳ"}}:::plan
    Access9 & Access10 --> Object11
    PgSelect8[["PgSelect[8∈0] ➊<br />ᐸbooksᐳ<br />More deps:<br />- Object[11]"]]:::plan
    __Value2["__Value[2∈0] ➊<br />ᐸcontextᐳ"]:::plan
    __Value2 --> Access9
    __Value2 --> Access10
    Connection12[["Connection[12∈0] ➊<br />ᐸ8ᐳ"]]:::plan
    PgSelect8 --> Connection12
    ConnectionItems14[["ConnectionItems[14∈0] ➊"]]:::plan
    Connection12 --> ConnectionItems14
    __Item17[/"__Item[17∈3]<br />ᐸ14ᐳ"\]:::itemplan
    ConnectionItems14 ==> __Item17
    PgSelectSingle18{{"PgSelectSingle[18∈3]<br />ᐸbooksᐳ"}}:::plan
    __Item17 --> PgSelectSingle18
    PgSelect21[["PgSelect[21∈4]<br />ᐸpeopleᐳ<br />More deps:<br />- Object[11]"]]:::plan
    PgClassExpression25{{"PgClassExpression[25∈4]<br />ᐸ__books__.”id”ᐳ"}}:::plan
    PgClassExpression25 --> PgSelect21
    PgClassExpression19{{"PgClassExpression[19∈4]<br />ᐸ__books__.”title”ᐳ"}}:::plan
    PgSelectSingle18 --> PgClassExpression19
    PgSelectSingle18 --> PgClassExpression25
    Connection26[["Connection[26∈4]<br />ᐸ21ᐳ"]]:::plan
    PgSelect21 --> Connection26
    ConnectionItems28[["ConnectionItems[28∈4]"]]:::plan
    Connection26 --> ConnectionItems28
    __Item31[/"__Item[31∈6]<br />ᐸ28ᐳ"\]:::itemplan
    ConnectionItems28 ==> __Item31
    PgSelectSingle32{{"PgSelectSingle[32∈6]<br />ᐸpeopleᐳ"}}:::plan
    __Item31 --> PgSelectSingle32
    PgClassExpression33{{"PgClassExpression[33∈7]<br />ᐸ__people__.”name”ᐳ"}}:::plan
    PgSelectSingle32 --> PgClassExpression33

    %% define steps
    classDef bucket0 stroke:#696969
    class Bucket0,__Value2,PgSelect8,Access9,Access10,Object11,Connection12,ConnectionItems14 bucket0
    classDef bucket1 stroke:#00bfff
    class Bucket1 bucket1
    classDef bucket3 stroke:#ffa500
    class Bucket3,__Item17,PgSelectSingle18 bucket3
    classDef bucket4 stroke:#0000ff
    class Bucket4,PgClassExpression19,PgSelect21,PgClassExpression25,Connection26,ConnectionItems28 bucket4
    classDef bucket6 stroke:#ff1493
    class Bucket6,__Item31,PgSelectSingle32 bucket6
    classDef bucket7 stroke:#808000
    class Bucket7,PgClassExpression33 bucket7

